UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BTe7eFhrrXnzPegDPkeHfQFyuWRNotIb+WRVcW+6jMw='
WHERE
key_id = 'a4638bc6de4c4beaf0d109abd0f7ca395780cdfe514c1ab3fa4a74b71e7d674a'
AND (
token = 'BTe7eFhrrXnzPegDPkeHfQFyuWRNotIb+WRVcW+6jMw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)