UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aN0BZTTW0r32oSvWGRXdAVfvx6cj42HFgMI+sG4m9To='
WHERE
key_id = 'd9c2988e7bb067fce2cca5621f77a6b2a7a62ff56f6055f3eb9e04124f85d7b2'
AND (
token = 'aN0BZTTW0r32oSvWGRXdAVfvx6cj42HFgMI+sG4m9To='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)