UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'a17vzZoKgMe2n6lSiCLhjZlbdcbXHTwZurMU8zLi1Vk='
WHERE
key_id = 'b48dbc2f09aea631fa8e8db60d50eaa2698ff43f6e1ef017fbd3ab6bdfa79362'
AND (
token = 'a17vzZoKgMe2n6lSiCLhjZlbdcbXHTwZurMU8zLi1Vk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)