UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0cHYVHyM1JdpdW9kgzb4K2LEllD/j9toKiqjTftN16M='
WHERE
key_id = 'd2073d483fb552f7bc03f352a06050877c4c84fd57134d42c233664b2ef655ac'
AND (
token = '0cHYVHyM1JdpdW9kgzb4K2LEllD/j9toKiqjTftN16M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)