UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cpfE0KYy4WSBW1/oQsUep4kN7Os1EDKigA5InAvVhXY='
WHERE
key_id = 'f7d0c08b10f064ac7c5b26c6c683af3c0647359d85e7187422e9213d7d19ccb9'
AND (
token = 'cpfE0KYy4WSBW1/oQsUep4kN7Os1EDKigA5InAvVhXY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)