UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'blk0JR0VSfKuBzhC7tFLqqZ7NGNaM0LuZ+1o2+kpRkY='
WHERE
key_id = '7ca6b7b324d0222709ce962befbb8dbcc711e02f1cf67015cb3d9243895105f4'
AND (
token = 'blk0JR0VSfKuBzhC7tFLqqZ7NGNaM0LuZ+1o2+kpRkY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)