UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lsxVX575zsp1LFYv7UGkBYnjBMdmwFT+7pNKiNRGIRo='
WHERE
key_id = '7adbb727ca58225befd49860df636bf19749b49b0c591727ea04c4f1b5f3fb80'
AND (
token = 'lsxVX575zsp1LFYv7UGkBYnjBMdmwFT+7pNKiNRGIRo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)