UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TNs+o1194n8u4JuPWEVfuLE1Z2jUgXww8Htlizoh5XQ='
WHERE
key_id = 'a7358c48adab28b59e6845fce3cfe8cc64ceb4c9902e46cfb48e9e5618d992b9'
AND (
token = 'TNs+o1194n8u4JuPWEVfuLE1Z2jUgXww8Htlizoh5XQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)