UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zfopFq5gPO4S8dvNcYwcHa94jNaqpiacvvbuLtVrgAE='
WHERE
key_id = '54740573bd28ab15e7087d89c15e8e95294001c15f81baf97c19e10f5366a69b'
AND (
token = 'zfopFq5gPO4S8dvNcYwcHa94jNaqpiacvvbuLtVrgAE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)