UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 's/9cHCzoabmdjkBkyrA9SrSkqRJiXscJMfUAt5rksYI='
WHERE
key_id = '6996b54998d7ed1e18d7b8aeb6ad94ee5eb1c8c6b079a8962c5ddabb6d04b2e9'
AND (
token = 's/9cHCzoabmdjkBkyrA9SrSkqRJiXscJMfUAt5rksYI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)