UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oHrhV39sBtWMfdgBJuyWT9QC6Ggl0FXVcvB3IxQGrRA='
WHERE
key_id = '40be2aa42dc76b5e069fc967fe1a7d41a2bb5a24fc1885df8bc9d6ae6ac3bcec'
AND (
token = 'oHrhV39sBtWMfdgBJuyWT9QC6Ggl0FXVcvB3IxQGrRA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)