UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'N6WrnP4D/+So3ovV4r3nIVo0vIcrfxonl6TKkeNsUII='
WHERE
key_id = '5f3649c7c9efc99feec88f22581eb1218ee16b9325613fba4664a43b75e1a745'
AND (
token = 'N6WrnP4D/+So3ovV4r3nIVo0vIcrfxonl6TKkeNsUII='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)