UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '59jtp6zkqdaTGgEzVXD78QGslBtoyvCXgzHfWZ/X148='
WHERE
key_id = '3a9d5c059c1a5a7ebad21f5745aa03453d4c84004a7f0a3eb428fbbbe981e45a'
AND (
token = '59jtp6zkqdaTGgEzVXD78QGslBtoyvCXgzHfWZ/X148='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)