UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2ZwxYlqG6iJWv70M53UZNXT0DGZu8nIq77iZlGTkPZ8='
WHERE
key_id = '4e4afee0c4a1052d928dc57f39457ae92250e3e23a6bb931cc3ea3c766a6c6d4'
AND (
token = '2ZwxYlqG6iJWv70M53UZNXT0DGZu8nIq77iZlGTkPZ8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)