UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bU/fvksEbSw8as+87ZV45d2cpBfCNBYewRxARupd8qI='
WHERE
key_id = '9b8524030c8dc9b2171f7e6de281faf0932739ce24b43cffa98a74728c2b187f'
AND (
token = 'bU/fvksEbSw8as+87ZV45d2cpBfCNBYewRxARupd8qI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)