UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'wGpoCaRxoFq3fg52vztS8jI86u1ANl1kRt+OdPTV9nM='
WHERE
key_id = 'ca7293812b3637b205f84b0a1830014fa36573fd8e9b3a1750e860eec696be6b'
AND (
token = 'wGpoCaRxoFq3fg52vztS8jI86u1ANl1kRt+OdPTV9nM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)