UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vW4ZIBPWPnCkolKVYCip3KeNFoGnQZfPIuWXfU1Bbhc='
WHERE
key_id = '9ae18448e71f40915d81bf944cebd3266ed9700958bc9b54e81e46ad36909dd4'
AND (
token = 'vW4ZIBPWPnCkolKVYCip3KeNFoGnQZfPIuWXfU1Bbhc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)