UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vRx5hnqrs8E+rUP8Duzv4/ZX/PSqozUCkUc8N+fVA44='
WHERE
key_id = '99d224d72c710195148d202a073cd905d6bc937a4b9f86b286ca418db75d9253'
AND (
token = 'vRx5hnqrs8E+rUP8Duzv4/ZX/PSqozUCkUc8N+fVA44='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)