UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0uUVt5gR3nNXF2EogQuOcsCaLujfpqqpD56XMWGlbgc='
WHERE
key_id = '2d504e5abf732cad52ce058fa336e7f7958ec919ff8dab7fa69ce10122a11799'
AND (
token = '0uUVt5gR3nNXF2EogQuOcsCaLujfpqqpD56XMWGlbgc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)