UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZtHjJwwlY4DYW20m28lBbjKrV9Iya6MtyJAa/0zW0xA='
WHERE
key_id = '496fa3143686f55fcacbaf996e69df9075821a01078817df4b12825d0588084c'
AND (
token = 'ZtHjJwwlY4DYW20m28lBbjKrV9Iya6MtyJAa/0zW0xA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)