UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'IuFifTEzsfYHg4yNsFrO1a3QKy6TOY+LUarD+yVSuHY='
WHERE
key_id = '478d88bbe8417a36d5e6f53fd36491cb1da5d2826d1160dbdf4a895e93d2f800'
AND (
token = 'IuFifTEzsfYHg4yNsFrO1a3QKy6TOY+LUarD+yVSuHY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)