UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hOlgA8SaBAhTGFz/vIm+n4yRN1gHAHZMO5I2skLh6kg='
WHERE
key_id = '7a20a098790e6e29edb3407357da10a2e01fd80973fc37f1835d5f2ed139d0a1'
AND (
token = 'hOlgA8SaBAhTGFz/vIm+n4yRN1gHAHZMO5I2skLh6kg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)