UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9nnuNcg7WkUQvOSWhZfZBpmA7oV7Lw8YKUcp5jhMenw='
WHERE
key_id = '8f4fb3791c864aed28ec0d5a456602a612abdf837fb6cf3c43d3966678a96ab7'
AND (
token = '9nnuNcg7WkUQvOSWhZfZBpmA7oV7Lw8YKUcp5jhMenw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)