UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ON0f0NCCtxNXGFsT7YPJGFjBnO7GNVq4sfJmlUExzCY='
WHERE
key_id = '5bfe696529aa4465e9f51fca8413cb388bf31c2f27ed13a2ae79fa7cde6239f4'
AND (
token = 'ON0f0NCCtxNXGFsT7YPJGFjBnO7GNVq4sfJmlUExzCY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)