UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'S9Lt47ucB6hZR4YHNmIbHgaciRCVMuk2ydL3q53WhlU='
WHERE
key_id = '90b3554ae74e29a62f3a55c6d08dbf24b664dacb5d8ab9d3c1a1547eb5396392'
AND (
token = 'S9Lt47ucB6hZR4YHNmIbHgaciRCVMuk2ydL3q53WhlU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)