UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3YkjQVmL1suxCwaHtiSvK0m9+mYt6JfC9LcjCRC9iXk='
WHERE
key_id = '0b5841b7943887474d44cb87207860e0f44d4123f3386c84567ae9b254ae8f2d'
AND (
token = '3YkjQVmL1suxCwaHtiSvK0m9+mYt6JfC9LcjCRC9iXk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)