UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GBOxUdQ0deG4uo9R2Jjtclj4qd9QnI80skfPVt5MAr8='
WHERE
key_id = '47a8c67b45c70657a481bb10ae92dced4789b11cb7ea6b588a86bea14a9b3f39'
AND (
token = 'GBOxUdQ0deG4uo9R2Jjtclj4qd9QnI80skfPVt5MAr8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)