UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'our6kPNjqFiWRvC9dtwhzgtpzqkEF/UVBH/kXwjj8Zo='
WHERE
key_id = '3c32330122a7784080e8d26dda870b5eb631a717ab830ab2acaf456d172619dc'
AND (
token = 'our6kPNjqFiWRvC9dtwhzgtpzqkEF/UVBH/kXwjj8Zo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)