UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BSJZHbzfGGYXCG8dh8XLbH20+RQtnEX7e3jdaAc5G0g='
WHERE
key_id = 'f75501308feda3360e04b562d8f00371798fbb923f1546c838c4554650a9205a'
AND (
token = 'BSJZHbzfGGYXCG8dh8XLbH20+RQtnEX7e3jdaAc5G0g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)