UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BWmY8/YkxrGMSycRGbDdSy9VLPr3JAmJTh135TWp7Ns='
WHERE
key_id = 'c9fe95aab00a2a38ffd4e53aeef01d79ae85554c0347e2ba8c66503875ab21d9'
AND (
token = 'BWmY8/YkxrGMSycRGbDdSy9VLPr3JAmJTh135TWp7Ns='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)