UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vxgEOIDTX9F0Z+irJpANN5tf8P1tJa2Rim6AGI/qIfo='
WHERE
key_id = '1b436032f366edfd101733a28a9c47139cbb83c9a04a538573f96c966f13f971'
AND (
token = 'vxgEOIDTX9F0Z+irJpANN5tf8P1tJa2Rim6AGI/qIfo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)