UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Oo8NCILJFOk6xV5Tx6iXlYrOqhtYeWeaXE1mmKikS8M='
WHERE
key_id = '99b7efea9e07da58cd07e2242ce3c15da1987eddfddcd64d95490167c161f877'
AND (
token = 'Oo8NCILJFOk6xV5Tx6iXlYrOqhtYeWeaXE1mmKikS8M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)