UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SfRldw6J0UJNw+1avsXEwzJguJvY/m8d2KDsWIj+Wkw='
WHERE
key_id = '8fc813713aa0c57d5b22bf025f00143a54079d2245352b7b346e3592acd6508d'
AND (
token = 'SfRldw6J0UJNw+1avsXEwzJguJvY/m8d2KDsWIj+Wkw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)