UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LG28kHM7q8Doy+V8CnGIkLbljgPviRsC+av44fqpWCI='
WHERE
key_id = '6e73546a91a185e38c88a891b59397fc75202ef10130f9911100cabfa91a25e0'
AND (
token = 'LG28kHM7q8Doy+V8CnGIkLbljgPviRsC+av44fqpWCI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)