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