UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HHZplttou9lGxMOJj24e33Sm84HyJLzJsTqmJG7BOEM='
WHERE
key_id = '4e6d1495e54be65613b63ee758f345ac373b0bcf4d46e50cca73d5446c18bd96'
AND (
token = 'HHZplttou9lGxMOJj24e33Sm84HyJLzJsTqmJG7BOEM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)