UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8HnveVGsWhEvQy6LmadSKbNqyPEELhBL0M7eGI51FbM='
WHERE
key_id = '473926506d3bf3c8af0fa918d42459c72ba28f99019d18edbb16c1fed3923ce3'
AND (
token = '8HnveVGsWhEvQy6LmadSKbNqyPEELhBL0M7eGI51FbM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)