UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CZ2i5B+qWthEjuQl4GXzzRaJ70lGiJZObpItsYxQMbg='
WHERE
key_id = 'f20b37466966276e310e8e111119e25c9513887f71401cde6f7651fd8cefe2f0'
AND (
token = 'CZ2i5B+qWthEjuQl4GXzzRaJ70lGiJZObpItsYxQMbg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)