UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7esPCzqQdF8vL4jHaedwVOChsBK7NS52ns06m8wOoD8='
WHERE
key_id = '47e750f1e1c1d292b456a3c2e91042db55a588f537d4e85b89220fc6ea3499d0'
AND (
token = '7esPCzqQdF8vL4jHaedwVOChsBK7NS52ns06m8wOoD8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)